55917 - An exception might be generated during the ISHIPCANCEL process

Support

Submit a Problem
Update a Problem
Check Problem Status
SAS Administrators
Security Bulletins
License Assistance
Manage My Software Account
Downloads & Hot Fixes
Samples & SAS Notes

Problem Note 55917: An exception might be generated during the ISHIPCANCEL process

Details

About

Rate It

In SAS^® Merchandise Allocation, the following exception might be generated during the ISHIPCANCEL process:

Error ODBC Error occurred: Native Error 20001 [IMPS][ODBC Oracle Wire Protocol driver][Oracle]ORA-20001: Invalid table for truncate: maxdata.ishipcancel ORA-06512: at MAXDATA.P_TRUNCATE_TABLE , line 41 ORA-06512: at line 1)]

This exception is generated because the MAXDATA.P_TRUNCATE_TABLE procedure fails to truncate the applicable MAXDATA tables.

Note: SAS Merchandise Allocation and SAS^® Merchandise Planning share the same database.

Contact Technical Support for a workaround for this issue.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS Merchandise Allocation	Microsoft Windows Server 2008 R2	3.5	3.5_M1	9.4 TS1M2	9.4 TS1M2
		64-bit Enabled AIX	3.5	3.5_M1	9.4 TS1M2	9.4 TS1M2
		Linux for x64	3.5	3.5_M1	9.4 TS1M2	9.4 TS1M2

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

Type:	Problem Note
Priority:	high

Date Modified:	2015-07-21 10:08:22
Date Created:	2015-06-02 16:00:34